SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [dbo].[paCertificaObtenerTiposParticipantes]
-- < Registro de Actualizaciones >
-- 25-10-2006 

	@SeConsideraAsistente VARCHAR(1)

AS
SET NOCOUNT ON
SET DATEFORMAT DMY
SELECT idTipoParticipante AS ID, Descripcion
	FROM Tb_TiposParticipantes
	WHERE Asiste = @SeConsideraAsistente
	ORDER BY Descripcion
GO
GRANT EXECUTE ON  [dbo].[paCertificaObtenerTiposParticipantes] TO [Certificaciones]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerTiposParticipantes] TO [CertificacionesAdministracion]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerTiposParticipantes] TO [SoloVer]
GO
